Pandas Profiling Report

Dataset statistics

Number of variables	33
Number of observations	200759
Missing cells	350667
Missing cells (%)	5.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	52.1 MiB
Average record size in memory	272.0 B

Variable types

Categorical	18
DateTime	5
Numeric	10

Alerts

`Valor del Contrato` is highly overall correlated with `Saldo CDP`	High correlation
`Valor Facturado` is highly overall correlated with `Valor Pendiente de Pago` and 2 other fields	High correlation
`Valor Pendiente de Pago` is highly overall correlated with `Valor Facturado` and 2 other fields	High correlation
`Valor Pagado` is highly overall correlated with `Valor Facturado` and 2 other fields	High correlation
`Valor Pendiente de Ejecucion` is highly overall correlated with `Valor Facturado` and 2 other fields	High correlation
`Saldo CDP` is highly overall correlated with `Valor del Contrato`	High correlation
`Orden` is highly overall correlated with `Sector`	High correlation
`Sector` is highly overall correlated with `Orden`	High correlation
`Tipo de Contrato` is highly overall correlated with `Modalidad de Contratacion`	High correlation
`Modalidad de Contratacion` is highly overall correlated with `Tipo de Contrato` and 1 other fields	High correlation
`Es Pyme` is highly overall correlated with `Modalidad de Contratacion`	High correlation
`Rama` is highly imbalanced (64.6%)	Imbalance
`Tipo de Contrato` is highly imbalanced (76.8%)	Imbalance
`Modalidad de Contratacion` is highly imbalanced (67.8%)	Imbalance
`Condiciones de Entrega` is highly imbalanced (52.3%)	Imbalance
`Es Grupo` is highly imbalanced (94.3%)	Imbalance
`Habilita Pago Adelantado` is highly imbalanced (98.3%)	Imbalance
`Obligación Ambiental` is highly imbalanced (76.4%)	Imbalance
`EsPostConflicto` is highly imbalanced (96.8%)	Imbalance
`Fecha de Inicio de Ejecucion` has 175260 (87.3%) missing values	Missing
`Fecha de Fin de Ejecucion` has 175043 (87.2%) missing values	Missing
`Valor del Contrato` is highly skewed (γ1 = 396.339426)	Skewed
`Valor Facturado` is highly skewed (γ1 = 440.8915116)	Skewed
`Valor Pendiente de Pago` is highly skewed (γ1 = 206.5018514)	Skewed
`Valor Pagado` is highly skewed (γ1 = 440.6712478)	Skewed
`Valor Pendiente de Ejecucion` is highly skewed (γ1 = 98.58376524)	Skewed
`Saldo CDP` is highly skewed (γ1 = 170.4036904)	Skewed
`Dias Adicionados` is highly skewed (γ1 = 34.72227299)	Skewed
`Presupuesto General de la Nacion – PGN` is highly skewed (γ1 = 432.1474784)	Skewed
`Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)` is highly skewed (γ1 = 212.2501029)	Skewed
`Recursos Propios` is highly skewed (γ1 = 156.5093127)	Skewed
`Valor Facturado` has 83466 (41.6%) zeros	Zeros
`Valor Pendiente de Pago` has 73931 (36.8%) zeros	Zeros
`Valor Pagado` has 94006 (46.8%) zeros	Zeros
`Valor Pendiente de Ejecucion` has 73496 (36.6%) zeros	Zeros
`Saldo CDP` has 10804 (5.4%) zeros	Zeros
`Dias Adicionados` has 199682 (99.5%) zeros	Zeros
`Presupuesto General de la Nacion – PGN` has 162435 (80.9%) zeros	Zeros
`Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)` has 110781 (55.2%) zeros	Zeros
`Recursos Propios` has 166430 (82.9%) zeros	Zeros

Reproduction

Analysis started	2023-07-19 00:13:01.611328
Analysis finished	2023-07-19 00:14:05.183479
Duration	1 minute and 3.57 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

Departamento
Categorical

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Distrito Capital de Bogotá	58831
Valle del Cauca	23601
Antioquia	20089
Santander	14911
Meta	9354
Other values (29)	73973

Length

Max length	40
Median length	26
Mean length	14.416724
Min length	4

Characters and Unicode

Total characters	2894287
Distinct characters	45
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Distrito Capital de Bogotá
2nd row	Valle del Cauca
3rd row	Distrito Capital de Bogotá
4th row	Boyacá
5th row	Risaralda

Common Values

Value	Count	Frequency (%)
Distrito Capital de Bogotá	58831	29.3%
Valle del Cauca	23601	11.8%
Antioquia	20089	10.0%
Santander	14911	7.4%
Meta	9354	4.7%
Boyacá	8774	4.4%
Risaralda	6816	3.4%
Cundinamarca	6585	3.3%
Huila	5857	2.9%
Casanare	5572	2.8%
Other values (24)	40369	20.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	63784	14.3%
distrito	58831	13.2%
capital	58831	13.2%
bogotá	58831	13.2%
cauca	26058	5.9%
valle	23601	5.3%
del	23601	5.3%
antioquia	20089	4.5%
santander	19864	4.5%
meta	9354	2.1%
Other values (35)	81906	18.4%

Most occurring characters

Value	Count	Frequency (%)
a	379676	13.1%
t	301588	10.4%
i	256392	8.9%
	243991	8.4%
o	232236	8.0%
l	160618	5.5%
e	159463	5.5%
d	134681	4.7%
r	118137	4.1%
C	106987	3.7%
Other values (35)	800518	27.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2292931	79.2%
Uppercase Letter	355523	12.3%
Space Separator	243991	8.4%
Other Punctuation	1842	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	379676	16.6%
t	301588	13.2%
i	256392	11.2%
o	232236	10.1%
l	160618	7.0%
e	159463	7.0%
d	134681	5.9%
r	118137	5.2%
n	97475	4.3%
s	79133	3.5%
Other values (18)	373532	16.3%

Uppercase Letter

Value	Count	Frequency (%)
C	106987	30.1%
B	71681	20.2%
D	59614	16.8%
A	27167	7.6%
S	24115	6.8%
V	23880	6.7%
M	11149	3.1%
N	7545	2.1%
R	6816	1.9%
H	5857	1.6%
Other values (5)	10712	3.0%

Space Separator

Value	Count	Frequency (%)
	243991	100.0%

Other Punctuation

Value	Count	Frequency (%)
,	1842	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2648454	91.5%
Common	245833	8.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	379676	14.3%
t	301588	11.4%
i	256392	9.7%
o	232236	8.8%
l	160618	6.1%
e	159463	6.0%
d	134681	5.1%
r	118137	4.5%
C	106987	4.0%
n	97475	3.7%
Other values (33)	701201	26.5%

Common

Value	Count	Frequency (%)
	243991	99.3%
,	1842	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2809502	97.1%
None	84785	2.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	379676	13.5%
t	301588	10.7%
i	256392	9.1%
	243991	8.7%
o	232236	8.3%
l	160618	5.7%
e	159463	5.7%
d	134681	4.8%
r	118137	4.2%
C	106987	3.8%
Other values (30)	715733	25.5%

None

Value	Count	Frequency (%)
á	72120	85.1%
í	7532	8.9%
é	1991	2.3%
ñ	1809	2.1%
ó	1333	1.6%

Orden
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Territorial	127222
Nacional	70325
Corporación Autónoma	3212

Length

Max length	20
Median length	11
Mean length	10.093107
Min length	8

Characters and Unicode

Total characters	2026282
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Territorial
2nd row	Territorial
3rd row	Territorial
4th row	Territorial
5th row	Territorial

Common Values

Value	Count	Frequency (%)
Territorial	127222	63.4%
Nacional	70325	35.0%
Corporación Autónoma	3212	1.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
territorial	127222	62.4%
nacional	70325	34.5%
corporación	3212	1.6%
autónoma	3212	1.6%

Most occurring characters

Value	Count	Frequency (%)
r	388090	19.2%
i	327981	16.2%
a	274296	13.5%
o	207183	10.2%
l	197547	9.7%
t	130434	6.4%
T	127222	6.3%
e	127222	6.3%
n	76749	3.8%
c	73537	3.6%
Other values (8)	96021	4.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1819099	89.8%
Uppercase Letter	203971	10.1%
Space Separator	3212	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	388090	21.3%
i	327981	18.0%
a	274296	15.1%
o	207183	11.4%
l	197547	10.9%
t	130434	7.2%
e	127222	7.0%
n	76749	4.2%
c	73537	4.0%
ó	6424	0.4%
Other values (3)	9636	0.5%

Uppercase Letter

Value	Count	Frequency (%)
T	127222	62.4%
N	70325	34.5%
C	3212	1.6%
A	3212	1.6%

Space Separator

Value	Count	Frequency (%)
	3212	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2023070	99.8%
Common	3212	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	388090	19.2%
i	327981	16.2%
a	274296	13.6%
o	207183	10.2%
l	197547	9.8%
t	130434	6.4%
T	127222	6.3%
e	127222	6.3%
n	76749	3.8%
c	73537	3.6%
Other values (7)	92809	4.6%

Common

Value	Count	Frequency (%)
	3212	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2019858	99.7%
None	6424	0.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	388090	19.2%
i	327981	16.2%
a	274296	13.6%
o	207183	10.3%
l	197547	9.8%
t	130434	6.5%
T	127222	6.3%
e	127222	6.3%
n	76749	3.8%
c	73537	3.6%
Other values (7)	89597	4.4%

None

Value	Count	Frequency (%)
ó	6424	100.0%

Sector
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Servicio Público	53134
No aplica/No pertenece	31793
Salud y Protección Social	20832
Trabajo	16373
defensa	12535
Other values (20)	66092

Length

Max length	50
Median length	33
Mean length	17.449723
Min length	7

Characters and Unicode

Total characters	3503189
Distinct characters	43
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Planeación
2nd row	deportes
3rd row	Salud y Protección Social
4th row	Servicio Público
5th row	Servicio Público

Common Values

Value	Count	Frequency (%)
Servicio Público	53134	26.5%
No aplica/No pertenece	31793	15.8%
Salud y Protección Social	20832	10.4%
Trabajo	16373	8.2%
defensa	12535	6.2%
Ambiente y Desarrollo Sostenible	10499	5.2%
Educación Nacional	9876	4.9%
deportes	6439	3.2%
Cultura	6415	3.2%
Transporte	5542	2.8%
Other values (15)	27321	13.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
público	56300	12.0%
servicio	53134	11.3%
y	43216	9.2%
no	31793	6.8%
aplica/no	31793	6.8%
pertenece	31793	6.8%
social	23674	5.0%
salud	20832	4.4%
protección	20832	4.4%
trabajo	16373	3.5%
Other values (40)	140673	29.9%

Most occurring characters

Value	Count	Frequency (%)
i	344161	9.8%
e	330848	9.4%
o	310064	8.9%
c	302221	8.6%
	269654	7.7%
a	255513	7.3%
l	197048	5.6%
r	194550	5.6%
n	152337	4.3%
t	111396	3.2%
Other values (33)	1035397	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2831826	80.8%
Uppercase Letter	365989	10.4%
Space Separator	269654	7.7%
Other Punctuation	35720	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	344161	12.2%
e	330848	11.7%
o	310064	10.9%
c	302221	10.7%
a	255513	9.0%
l	197048	7.0%
r	194550	6.9%
n	152337	5.4%
t	111396	3.9%
b	94211	3.3%
Other values (15)	539477	19.1%

Uppercase Letter

Value	Count	Frequency (%)
S	108139	29.5%
P	81385	22.2%
N	73462	20.1%
T	27475	7.5%
C	15146	4.1%
E	12864	3.5%
A	10499	2.9%
D	10499	2.9%
I	7605	2.1%
V	3927	1.1%
Other values (5)	14988	4.1%

Other Punctuation

Value	Count	Frequency (%)
/	31793	89.0%
,	3927	11.0%

Space Separator

Value	Count	Frequency (%)
	269654	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3197815	91.3%
Common	305374	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	344161	10.8%
e	330848	10.3%
o	310064	9.7%
c	302221	9.5%
a	255513	8.0%
l	197048	6.2%
r	194550	6.1%
n	152337	4.8%
t	111396	3.5%
S	108139	3.4%
Other values (30)	891538	27.9%

Common

Value	Count	Frequency (%)
	269654	88.3%
/	31793	10.4%
,	3927	1.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3396009	96.9%
None	107180	3.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	344161	10.1%
e	330848	9.7%
o	310064	9.1%
c	302221	8.9%
	269654	7.9%
a	255513	7.5%
l	197048	5.8%
r	194550	5.7%
n	152337	4.5%
t	111396	3.3%
Other values (29)	928217	27.3%

None

Value	Count	Frequency (%)
ú	56840	53.0%
ó	42814	39.9%
í	4355	4.1%
é	3171	3.0%

Rama
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Ejecutivo	170273
Corporación Autónoma	27130
Judicial	1752
Legislativo	1604

Length

Max length	20
Median length	9
Mean length	10.493761
Min length	8

Characters and Unicode

Total characters	2106717
Distinct characters	24
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ejecutivo
2nd row	Ejecutivo
3rd row	Ejecutivo
4th row	Ejecutivo
5th row	Ejecutivo

Common Values

Value	Count	Frequency (%)
Ejecutivo	170273	84.8%
Corporación Autónoma	27130	13.5%
Judicial	1752	0.9%
Legislativo	1604	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ejecutivo	170273	74.7%
corporación	27130	11.9%
autónoma	27130	11.9%
judicial	1752	0.8%
legislativo	1604	0.7%

Most occurring characters

Value	Count	Frequency (%)
o	253267	12.0%
i	204115	9.7%
c	199155	9.5%
u	199155	9.5%
t	199007	9.4%
e	171877	8.2%
v	171877	8.2%
E	170273	8.1%
j	170273	8.1%
a	57616	2.7%
Other values (14)	310102	14.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1851698	87.9%
Uppercase Letter	227889	10.8%
Space Separator	27130	1.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	253267	13.7%
i	204115	11.0%
c	199155	10.8%
u	199155	10.8%
t	199007	10.7%
e	171877	9.3%
v	171877	9.3%
j	170273	9.2%
a	57616	3.1%
r	54260	2.9%
Other values (8)	171096	9.2%

Uppercase Letter

Value	Count	Frequency (%)
E	170273	74.7%
C	27130	11.9%
A	27130	11.9%
J	1752	0.8%
L	1604	0.7%

Space Separator

Value	Count	Frequency (%)
	27130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2079587	98.7%
Common	27130	1.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	253267	12.2%
i	204115	9.8%
c	199155	9.6%
u	199155	9.6%
t	199007	9.6%
e	171877	8.3%
v	171877	8.3%
E	170273	8.2%
j	170273	8.2%
a	57616	2.8%
Other values (13)	282972	13.6%

Common

Value	Count	Frequency (%)
	27130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2052457	97.4%
None	54260	2.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	253267	12.3%
i	204115	9.9%
c	199155	9.7%
u	199155	9.7%
t	199007	9.7%
e	171877	8.4%
v	171877	8.4%
E	170273	8.3%
j	170273	8.3%
a	57616	2.8%
Other values (13)	255842	12.5%

None

Value	Count	Frequency (%)
ó	54260	100.0%

Entidad Centralizada
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Descentralizada	105639
Centralizada	86861
No Definido	8259

Length

Max length	15
Median length	15
Mean length	13.537455
Min length	11

Characters and Unicode

Total characters	2717766
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Centralizada
2nd row	Descentralizada
3rd row	Descentralizada
4th row	Descentralizada
5th row	Descentralizada

Common Values

Value	Count	Frequency (%)
Descentralizada	105639	52.6%
Centralizada	86861	43.3%
No Definido	8259	4.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
descentralizada	105639	50.5%
centralizada	86861	41.6%
no	8259	4.0%
definido	8259	4.0%

Most occurring characters

Value	Count	Frequency (%)
a	577500	21.2%
e	306398	11.3%
i	209018	7.7%
d	200759	7.4%
n	200759	7.4%
l	192500	7.1%
z	192500	7.1%
t	192500	7.1%
r	192500	7.1%
D	113898	4.2%
Other values (7)	339434	12.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2500489	92.0%
Uppercase Letter	209018	7.7%
Space Separator	8259	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	577500	23.1%
e	306398	12.3%
i	209018	8.4%
d	200759	8.0%
n	200759	8.0%
l	192500	7.7%
z	192500	7.7%
t	192500	7.7%
r	192500	7.7%
c	105639	4.2%
Other values (3)	130416	5.2%

Uppercase Letter

Value	Count	Frequency (%)
D	113898	54.5%
C	86861	41.6%
N	8259	4.0%

Space Separator

Value	Count	Frequency (%)
	8259	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2709507	99.7%
Common	8259	0.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	577500	21.3%
e	306398	11.3%
i	209018	7.7%
d	200759	7.4%
n	200759	7.4%
l	192500	7.1%
z	192500	7.1%
t	192500	7.1%
r	192500	7.1%
D	113898	4.2%
Other values (6)	331175	12.2%

Common

Value	Count	Frequency (%)
	8259	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2717766	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	577500	21.2%
e	306398	11.3%
i	209018	7.7%
d	200759	7.4%
n	200759	7.4%
l	192500	7.1%
z	192500	7.1%
t	192500	7.1%
r	192500	7.1%
D	113898	4.2%
Other values (7)	339434	12.5%

Estado Contrato
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

terminado	125519
Cerrado	66538
cedido	7398
Suspendido	1304

Length

Max length	10
Median length	9
Mean length	8.2330805
Min length	6

Characters and Unicode

Total characters	1652865
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	terminado
2nd row	Cerrado
3rd row	terminado
4th row	terminado
5th row	Cerrado

Common Values

Value	Count	Frequency (%)
terminado	125519	62.5%
Cerrado	66538	33.1%
cedido	7398	3.7%
Suspendido	1304	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
terminado	125519	62.5%
cerrado	66538	33.1%
cedido	7398	3.7%
suspendido	1304	0.6%

Most occurring characters

Value	Count	Frequency (%)
r	258595	15.6%
d	209461	12.7%
e	200759	12.1%
o	200759	12.1%
a	192057	11.6%
i	134221	8.1%
n	126823	7.7%
t	125519	7.6%
m	125519	7.6%
C	66538	4.0%
Other values (5)	12614	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1585023	95.9%
Uppercase Letter	67842	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	258595	16.3%
d	209461	13.2%
e	200759	12.7%
o	200759	12.7%
a	192057	12.1%
i	134221	8.5%
n	126823	8.0%
t	125519	7.9%
m	125519	7.9%
c	7398	0.5%
Other values (3)	3912	0.2%

Uppercase Letter

Value	Count	Frequency (%)
C	66538	98.1%
S	1304	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1652865	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	258595	15.6%
d	209461	12.7%
e	200759	12.1%
o	200759	12.1%
a	192057	11.6%
i	134221	8.1%
n	126823	7.7%
t	125519	7.6%
m	125519	7.6%
C	66538	4.0%
Other values (5)	12614	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1652865	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	258595	15.6%
d	209461	12.7%
e	200759	12.1%
o	200759	12.1%
a	192057	11.6%
i	134221	8.1%
n	126823	7.7%
t	125519	7.6%
m	125519	7.6%
C	66538	4.0%
Other values (5)	12614	0.8%

Tipo de Contrato
Categorical

HIGH CORRELATION IMBALANCE

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Prestación de servicios	170592
Otro	8209
Suministros	6364
Compraventa	5776
DecreeLaw092/2017	4752
Other values (16)	5066

Length

Max length	26
Median length	23
Mean length	21.126674
Min length	4

Characters and Unicode

Total characters	4241370
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Prestación de servicios
2nd row	Prestación de servicios
3rd row	Prestación de servicios
4th row	Prestación de servicios
5th row	Prestación de servicios

Common Values

Value	Count	Frequency (%)
Prestación de servicios	170592	85.0%
Otro	8209	4.1%
Suministros	6364	3.2%
Compraventa	5776	2.9%
DecreeLaw092/2017	4752	2.4%
Arrendamiento de inmuebles	1612	0.8%
Obra	1604	0.8%
Consultoría	418	0.2%
No Especificado	416	0.2%
Interventoría	376	0.2%
Other values (11)	640	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	172269	31.6%
servicios	170618	31.3%
prestación	170592	31.3%
otro	8209	1.5%
suministros	6364	1.2%
compraventa	5776	1.1%
decreelaw092/2017	4752	0.9%
arrendamiento	1677	0.3%
inmuebles	1614	0.3%
obra	1604	0.3%
Other values (17)	2296	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	541679	12.8%
i	528799	12.5%
s	527316	12.4%
r	372694	8.8%
c	346851	8.2%
	345012	8.1%
o	195856	4.6%
t	194110	4.6%
a	191748	4.5%
n	188955	4.5%
Other values (30)	808350	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3652401	86.1%
Space Separator	345012	8.1%
Uppercase Letter	205941	4.9%
Decimal Number	33264	0.8%
Other Punctuation	4752	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	541679	14.8%
i	528799	14.5%
s	527316	14.4%
r	372694	10.2%
c	346851	9.5%
o	195856	5.4%
t	194110	5.3%
a	191748	5.2%
n	188955	5.2%
v	176777	4.8%
Other values (12)	387616	10.6%

Uppercase Letter

Value	Count	Frequency (%)
P	170606	82.8%
O	9813	4.8%
S	6602	3.2%
C	6500	3.2%
D	4752	2.3%
L	4752	2.3%
A	1684	0.8%
E	422	0.2%
N	420	0.2%
I	376	0.2%

Decimal Number

Value	Count	Frequency (%)
2	9504	28.6%
0	9504	28.6%
7	4752	14.3%
1	4752	14.3%
9	4752	14.3%

Space Separator

Value	Count	Frequency (%)
	345012	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	4752	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3858342	91.0%
Common	383028	9.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	541679	14.0%
i	528799	13.7%
s	527316	13.7%
r	372694	9.7%
c	346851	9.0%
o	195856	5.1%
t	194110	5.0%
a	191748	5.0%
n	188955	4.9%
v	176777	4.6%
Other values (23)	593557	15.4%

Common

Value	Count	Frequency (%)
	345012	90.1%
2	9504	2.5%
0	9504	2.5%
7	4752	1.2%
1	4752	1.2%
/	4752	1.2%
9	4752	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4069960	96.0%
None	171410	4.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	541679	13.3%
i	528799	13.0%
s	527316	13.0%
r	372694	9.2%
c	346851	8.5%
	345012	8.5%
o	195856	4.8%
t	194110	4.8%
a	191748	4.7%
n	188955	4.6%
Other values (27)	636940	15.6%

None

Value	Count	Frequency (%)
ó	170609	99.5%
í	794	0.5%
ú	7	< 0.1%

Modalidad de Contratacion
Categorical

HIGH CORRELATION IMBALANCE

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Contratación directa	155358
Contratación régimen especial	19412
Mínima cuantía	15734
Selección Abreviada de Menor Cuantía	2588
Selección abreviada subasta inversa	2513
Other values (10)	5154

Length

Max length	59
Median length	20
Mean length	21.135745
Min length	11

Characters and Unicode

Total characters	4243191
Distinct characters	42
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Contratación directa
2nd row	Contratación directa
3rd row	Contratación régimen especial
4th row	Contratación directa
5th row	Contratación directa

Common Values

Value	Count	Frequency (%)
Contratación directa	155358	77.4%
Contratación régimen especial	19412	9.7%
Mínima cuantía	15734	7.8%
Selección Abreviada de Menor Cuantía	2588	1.3%
Selección abreviada subasta inversa	2513	1.3%
Contratación Directa (con ofertas)	2165	1.1%
Contratación régimen especial (con ofertas)	1264	0.6%
Licitación pública	515	0.3%
No Definido	320	0.2%
Licitación pública Obra Publica	318	0.2%
Other values (5)	572	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
contratación	178199	40.2%
directa	157523	35.5%
régimen	20676	4.7%
especial	20676	4.7%
cuantía	18322	4.1%
mínima	15734	3.5%
abreviada	5161	1.2%
selección	5101	1.2%
con	3443	0.8%
ofertas	3429	0.8%
Other values (23)	14997	3.4%

Most occurring characters

Value	Count	Frequency (%)
a	614053	14.5%
t	540387	12.7%
n	427090	10.1%
i	411385	9.7%
c	389295	9.2%
r	372236	8.8%
e	247782	5.8%
	242502	5.7%
o	190677	4.5%
ó	184147	4.3%
Other values (32)	623637	14.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3778443	89.0%
Space Separator	242502	5.7%
Uppercase Letter	213508	5.0%
Open Punctuation	3429	0.1%
Close Punctuation	3429	0.1%
Connector Punctuation	940	< 0.1%
Decimal Number	564	< 0.1%
Dash Punctuation	376	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	614053	16.3%
t	540387	14.3%
n	427090	11.3%
i	411385	10.9%
c	389295	10.3%
r	372236	9.9%
e	247782	6.6%
o	190677	5.0%
ó	184147	4.9%
d	163760	4.3%
Other values (13)	237631	6.3%

Uppercase Letter

Value	Count	Frequency (%)
C	181909	85.2%
M	18630	8.7%
S	5597	2.6%
A	2648	1.2%
D	2485	1.2%
L	1021	0.5%
N	320	0.1%
P	318	0.1%
O	318	0.1%
E	202	0.1%

Decimal Number

Value	Count	Frequency (%)
2	188	33.3%
0	188	33.3%
1	188	33.3%

Space Separator

Value	Count	Frequency (%)
	242502	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3429	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3429	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	940	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	376	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3991951	94.1%
Common	251240	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	614053	15.4%
t	540387	13.5%
n	427090	10.7%
i	411385	10.3%
c	389295	9.8%
r	372236	9.3%
e	247782	6.2%
o	190677	4.8%
ó	184147	4.6%
C	181909	4.6%
Other values (24)	432990	10.8%

Common

Value	Count	Frequency (%)
	242502	96.5%
(	3429	1.4%
)	3429	1.4%
_	940	0.4%
-	376	0.1%
2	188	0.1%
0	188	0.1%
1	188	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4003169	94.3%
None	240022	5.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	614053	15.3%
t	540387	13.5%
n	427090	10.7%
i	411385	10.3%
c	389295	9.7%
r	372236	9.3%
e	247782	6.2%
	242502	6.1%
o	190677	4.8%
C	181909	4.5%
Other values (28)	385853	9.6%

None

Value	Count	Frequency (%)
ó	184147	76.7%
í	34056	14.2%
é	20986	8.7%
ú	833	0.3%

Fecha de Firma
Date

Distinct	1551
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Minimum	2018-01-25 00:00:00
Maximum	2023-07-08 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Inicio del Contrato
Date

Distinct	1552
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Minimum	2019-01-01 00:00:00
Maximum	2023-10-03 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Fin del Contrato
Date

Distinct	1957
Distinct (%)	1.0%
Missing	2
Missing (%)	< 0.1%
Memory size	3.1 MiB

Minimum	2019-01-02 00:00:00
Maximum	2042-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Inicio de Ejecucion
Date

Distinct	552
Distinct (%)	2.2%
Missing	175260
Missing (%)	87.3%
Memory size	3.1 MiB

Minimum	2009-01-18 00:00:00
Maximum	2021-10-25 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Fecha de Fin de Ejecucion
Date

Distinct	934
Distinct (%)	3.6%
Missing	175043
Missing (%)	87.2%
Memory size	3.1 MiB

Minimum	2018-12-07 00:00:00
Maximum	2034-11-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Condiciones de Entrega
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

A convenir	80963
Como acordado previamente	65375
No Definido	42134
Transporte incluido	10892
Transporte no incluído	647
Other values (9)	748

Length

Max length	58
Median length	56
Mean length	15.774426
Min length	10

Characters and Unicode

Total characters	3166858
Distinct characters	38
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	No Definido
2nd row	Como acordado previamente
3rd row	A convenir
4th row	A convenir
5th row	A convenir

Common Values

Value	Count	Frequency (%)
A convenir	80963	40.3%
Como acordado previamente	65375	32.6%
No Definido	42134	21.0%
Transporte incluido	10892	5.4%
Transporte no incluído	647	0.3%
DAP - Entregado en un punto (lugar de destino convenido)	588	0.3%
Transporte a cargo del comprador	115	0.1%
DAT - Delivery at terminal	13	< 0.1%
CPT - Transporte pagado hasta (lugar de destino convenido)	11	< 0.1%
CIP - Carriage and insurance paid to	11	< 0.1%
Other values (4)	10	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	81078	17.1%
convenir	80963	17.1%
como	65375	13.8%
acordado	65375	13.8%
previamente	65375	13.8%
no	42781	9.0%
definido	42134	8.9%
transporte	11665	2.5%
incluido	10892	2.3%
incluído	647	0.1%
Other values (37)	6502	1.4%

Most occurring characters

Value	Count	Frequency (%)
o	453928	14.3%
e	334053	10.5%
n	297486	9.4%
	272028	8.6%
i	254303	8.0%
r	236647	7.5%
a	209456	6.6%
d	187079	5.9%
c	158720	5.0%
v	146953	4.6%
Other values (28)	616205	19.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2648204	83.6%
Space Separator	272028	8.6%
Uppercase Letter	244794	7.7%
Dash Punctuation	634	< 0.1%
Open Punctuation	599	< 0.1%
Close Punctuation	599	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	453928	17.1%
e	334053	12.6%
n	297486	11.2%
i	254303	9.6%
r	236647	8.9%
a	209456	7.9%
d	187079	7.1%
c	158720	6.0%
v	146953	5.5%
m	130878	4.9%
Other values (12)	238701	9.0%

Uppercase Letter

Value	Count	Frequency (%)
A	81565	33.3%
C	65420	26.7%
D	42757	17.5%
N	42134	17.2%
T	11689	4.8%
P	613	0.3%
E	590	0.2%
I	11	< 0.1%
F	7	< 0.1%
R	5	< 0.1%
Other values (2)	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	272028	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	634	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	599	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	599	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2892998	91.4%
Common	273860	8.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	453928	15.7%
e	334053	11.5%
n	297486	10.3%
i	254303	8.8%
r	236647	8.2%
a	209456	7.2%
d	187079	6.5%
c	158720	5.5%
v	146953	5.1%
m	130878	4.5%
Other values (24)	483495	16.7%

Common

Value	Count	Frequency (%)
	272028	99.3%
-	634	0.2%
(	599	0.2%
)	599	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3166211	> 99.9%
None	647	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	453928	14.3%
e	334053	10.6%
n	297486	9.4%
	272028	8.6%
i	254303	8.0%
r	236647	7.5%
a	209456	6.6%
d	187079	5.9%
c	158720	5.0%
v	146953	4.6%
Other values (27)	615558	19.4%

None

Value	Count	Frequency (%)
í	647	100.0%

Es Grupo
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	199448
Si	1311

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	401518
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	199448	99.3%
Si	1311	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	199448	99.3%
si	1311	0.7%

Most occurring characters

Value	Count	Frequency (%)
N	199448	49.7%
o	199448	49.7%
S	1311	0.3%
i	1311	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	200759	50.0%
Lowercase Letter	200759	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	199448	99.3%
S	1311	0.7%

Lowercase Letter

Value	Count	Frequency (%)
o	199448	99.3%
i	1311	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	401518	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	199448	49.7%
o	199448	49.7%
S	1311	0.3%
i	1311	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	401518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	199448	49.7%
o	199448	49.7%
S	1311	0.3%
i	1311	0.3%

Es Pyme
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	163189
Si	37570

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	401518
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	Si
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	163189	81.3%
Si	37570	18.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	163189	81.3%
si	37570	18.7%

Most occurring characters

Value	Count	Frequency (%)
N	163189	40.6%
o	163189	40.6%
S	37570	9.4%
i	37570	9.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	200759	50.0%
Lowercase Letter	200759	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	163189	81.3%
S	37570	18.7%

Lowercase Letter

Value	Count	Frequency (%)
o	163189	81.3%
i	37570	18.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	401518	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	163189	40.6%
o	163189	40.6%
S	37570	9.4%
i	37570	9.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	401518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	163189	40.6%
o	163189	40.6%
S	37570	9.4%
i	37570	9.4%

Habilita Pago Adelantado
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	200276
No Definido	363
Si	120

Length

Max length	11
Median length	2
Mean length	2.0162732
Min length	2

Characters and Unicode

Total characters	404785
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	200276	99.8%
No Definido	363	0.2%
Si	120	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	200639	99.8%
definido	363	0.2%
si	120	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	201002	49.7%
N	200639	49.6%
i	846	0.2%
	363	0.1%
D	363	0.1%
e	363	0.1%
f	363	0.1%
n	363	0.1%
d	363	0.1%
S	120	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	203300	50.2%
Uppercase Letter	201122	49.7%
Space Separator	363	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	201002	98.9%
i	846	0.4%
e	363	0.2%
f	363	0.2%
n	363	0.2%
d	363	0.2%

Uppercase Letter

Value	Count	Frequency (%)
N	200639	99.8%
D	363	0.2%
S	120	0.1%

Space Separator

Value	Count	Frequency (%)
	363	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	404422	99.9%
Common	363	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	201002	49.7%
N	200639	49.6%
i	846	0.2%
D	363	0.1%
e	363	0.1%
f	363	0.1%
n	363	0.1%
d	363	0.1%
S	120	< 0.1%

Common

Value	Count	Frequency (%)
	363	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	404785	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	201002	49.7%
N	200639	49.6%
i	846	0.2%
	363	0.1%
D	363	0.1%
e	363	0.1%
f	363	0.1%
n	363	0.1%
d	363	0.1%
S	120	< 0.1%

Liquidación
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	171309
Si	29450

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	401518
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	171309	85.3%
Si	29450	14.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	171309	85.3%
si	29450	14.7%

Most occurring characters

Value	Count	Frequency (%)
N	171309	42.7%
o	171309	42.7%
S	29450	7.3%
i	29450	7.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	200759	50.0%
Lowercase Letter	200759	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	171309	85.3%
S	29450	14.7%

Lowercase Letter

Value	Count	Frequency (%)
o	171309	85.3%
i	29450	14.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	401518	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	171309	42.7%
o	171309	42.7%
S	29450	7.3%
i	29450	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	401518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	171309	42.7%
o	171309	42.7%
S	29450	7.3%
i	29450	7.3%

Obligación Ambiental
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	192994
Si	7765

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	401518
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	192994	96.1%
Si	7765	3.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	192994	96.1%
si	7765	3.9%

Most occurring characters

Value	Count	Frequency (%)
N	192994	48.1%
o	192994	48.1%
S	7765	1.9%
i	7765	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	200759	50.0%
Lowercase Letter	200759	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	192994	96.1%
S	7765	3.9%

Lowercase Letter

Value	Count	Frequency (%)
o	192994	96.1%
i	7765	3.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	401518	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	192994	48.1%
o	192994	48.1%
S	7765	1.9%
i	7765	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	401518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	192994	48.1%
o	192994	48.1%
S	7765	1.9%
i	7765	1.9%

Valor del Contrato
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	83739
Distinct (%)	41.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1299236 × 10⁸

Minimum	0
Maximum	1.7997072 × 10¹²
Zeros	867
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	3200000
Q1	9462000
median	18569870
Q3	37700000
95-th percentile	2.1261877 × 10⁸
Maximum	1.7997072 × 10¹²
Range	1.7997072 × 10¹²
Interquartile range (IQR)	28238000

Descriptive statistics

Standard deviation	4.1908862 × 10⁹
Coefficient of variation (CV)	37.089995
Kurtosis	169430.28
Mean	1.1299236 × 10⁸
Median Absolute Deviation (MAD)	11397116
Skewness	396.33943
Sum	2.2684234 × 10¹³
Variance	1.7563527 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12000000	1702	0.8%
9000000	1476	0.7%
6000000	1468	0.7%
15000000	1361	0.7%
18000000	1259	0.6%
10000000	1247	0.6%
21000000	1040	0.5%
8000000	942	0.5%
20000000	886	0.4%
0	867	0.4%
Other values (83729)	188511	93.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	867	0.4%
1	5	< 0.1%
4	1	< 0.1%
34	1	< 0.1%
990	1	< 0.1%
3670	1	< 0.1%
7790	1	< 0.1%
9149	1	< 0.1%
13685	1	< 0.1%
13800	1	< 0.1%

Value	Count	Frequency (%)
1.79970725 × 10¹²	1	< 0.1%
2.133450183 × 10¹¹	1	< 0.1%
1.865070701 × 10¹¹	1	< 0.1%
1.432822371 × 10¹¹	1	< 0.1%
1.179277155 × 10¹¹	1	< 0.1%
9.699 × 10¹⁰	1	< 0.1%
9.518281839 × 10¹⁰	1	< 0.1%
9.468352547 × 10¹⁰	1	< 0.1%
8.487290598 × 10¹⁰	1	< 0.1%
8.022376125 × 10¹⁰	1	< 0.1%

Valor Facturado
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	56981
Distinct (%)	28.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44617793

Minimum	0
Maximum	1.7906829 × 10¹²
Zeros	83466
Zeros (%)	41.6%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5724000
Q3	20429991
95-th percentile	66990953
Maximum	1.7906829 × 10¹²
Range	1.7906829 × 10¹²
Interquartile range (IQR)	20429991

Descriptive statistics

Standard deviation	4.0181841 × 10⁹
Coefficient of variation (CV)	90.057887
Kurtosis	196447.79
Mean	44617793
Median Absolute Deviation (MAD)	5724000
Skewness	440.89151
Sum	8.9574235 × 10¹²
Variance	1.6145804 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	83466	41.6%
12000000	983	0.5%
6000000	936	0.5%
15000000	824	0.4%
9000000	810	0.4%
18000000	736	0.4%
10000000	735	0.4%
8000000	600	0.3%
21000000	562	0.3%
7500000	540	0.3%
Other values (56971)	110567	55.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	83466	41.6%
2	1	< 0.1%
3	1	< 0.1%
20	1	< 0.1%
46	1	< 0.1%
669	1	< 0.1%
759	1	< 0.1%
5000	1	< 0.1%
7790	1	< 0.1%
29634	1	< 0.1%

Value	Count	Frequency (%)
1.790682932 × 10¹²	1	< 0.1%
6.819932803 × 10¹⁰	1	< 0.1%
3.98360464 × 10¹⁰	1	< 0.1%
3.777576256 × 10¹⁰	1	< 0.1%
3.6525104 × 10¹⁰	1	< 0.1%
3.236956363 × 10¹⁰	1	< 0.1%
3.050190129 × 10¹⁰	1	< 0.1%
2.751613912 × 10¹⁰	1	< 0.1%
2.7 × 10¹⁰	1	< 0.1%
2.641529826 × 10¹⁰	1	< 0.1%

Valor Pendiente de Pago
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	62651
Distinct (%)	31.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76775385

Minimum	-1.398232 × 10⁸
Maximum	6.0072888 × 10¹¹
Zeros	73931
Zeros (%)	36.8%
Negative	342
Negative (%)	0.2%
Memory size	3.1 MiB

Quantile statistics

Minimum	-1.398232 × 10⁸
5-th percentile	0
Q1	0
median	4247383
Q3	18925015
95-th percentile	1.172 × 10⁸
Maximum	6.0072888 × 10¹¹
Range	6.0086871 × 10¹¹
Interquartile range (IQR)	18925015

Descriptive statistics

Standard deviation	1.8308169 × 10⁹
Coefficient of variation (CV)	23.846404
Kurtosis	60431.785
Mean	76775385
Median Absolute Deviation (MAD)	4247383
Skewness	206.50185
Sum	1.5413349 × 10¹³
Variance	3.3518905 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73931	36.8%
12000000	762	0.4%
9000000	758	0.4%
6000000	752	0.4%
1	693	0.3%
18000000	597	0.3%
10000000	582	0.3%
3000000	574	0.3%
15000000	565	0.3%
4000000	486	0.2%
Other values (62641)	121059	60.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-139823200	1	< 0.1%
-130438820	1	< 0.1%
-88271811	1	< 0.1%
-80483971	1	< 0.1%
-72765756	1	< 0.1%
-49673584	1	< 0.1%
-49599996	1	< 0.1%
-49524712	1	< 0.1%
-43750000	1	< 0.1%
-41284040	1	< 0.1%

Value	Count	Frequency (%)
6.007288838 × 10¹¹	1	< 0.1%
2.133450183 × 10¹¹	1	< 0.1%
1.89810009 × 10¹¹	1	< 0.1%
1.865070701 × 10¹¹	1	< 0.1%
1.459392215 × 10¹¹	1	< 0.1%
1.432822371 × 10¹¹	1	< 0.1%
1.179277155 × 10¹¹	1	< 0.1%
9.689301 × 10¹⁰	1	< 0.1%
9.518281839 × 10¹⁰	1	< 0.1%
9.468352547 × 10¹⁰	1	< 0.1%

Valor Pagado
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	52548
Distinct (%)	26.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40502412

Minimum	0
Maximum	1.653768 × 10¹²
Zeros	94006
Zeros (%)	46.8%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3200000
Q3	18290000
95-th percentile	61168918
Maximum	1.653768 × 10¹²
Range	1.653768 × 10¹²
Interquartile range (IQR)	18290000

Descriptive statistics

Standard deviation	3.711574 × 10⁹
Coefficient of variation (CV)	91.638343
Kurtosis	196317.12
Mean	40502412
Median Absolute Deviation (MAD)	3200000
Skewness	440.67125
Sum	8.1312238 × 10¹²
Variance	1.3775781 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	94006	46.8%
12000000	868	0.4%
6000000	803	0.4%
9000000	740	0.4%
15000000	711	0.4%
10000000	655	0.3%
18000000	623	0.3%
8000000	531	0.3%
21000000	492	0.2%
7500000	434	0.2%
Other values (52538)	100896	50.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	94006	46.8%
2	1	< 0.1%
3	1	< 0.1%
20	1	< 0.1%
46	1	< 0.1%
669	1	< 0.1%
759	1	< 0.1%
4034	1	< 0.1%
5000	1	< 0.1%
7790	1	< 0.1%

Value	Count	Frequency (%)
1.653768028 × 10¹²	1	< 0.1%
5.818033414 × 10¹⁰	1	< 0.1%
3.98360464 × 10¹⁰	1	< 0.1%
3.6525104 × 10¹⁰	1	< 0.1%
3.255813844 × 10¹⁰	1	< 0.1%
2.751613912 × 10¹⁰	1	< 0.1%
2.7 × 10¹⁰	1	< 0.1%
2.605258884 × 10¹⁰	1	< 0.1%
2.583476979 × 10¹⁰	1	< 0.1%
2.523522504 × 10¹⁰	1	< 0.1%

Valor Pendiente de Ejecucion
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	62687
Distinct (%)	31.3%
Missing	362
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	71743284

Minimum	-1.398232 × 10⁸
Maximum	2.1334502 × 10¹¹
Zeros	73496
Zeros (%)	36.6%
Negative	338
Negative (%)	0.2%
Memory size	3.1 MiB

Quantile statistics

Minimum	-1.398232 × 10⁸
5-th percentile	0
Q1	0
median	4299750
Q3	19000000
95-th percentile	1.1757528 × 10⁸
Maximum	2.1334502 × 10¹¹
Range	2.1348484 × 10¹¹
Interquartile range (IQR)	19000000

Descriptive statistics

Standard deviation	1.1168111 × 10⁹
Coefficient of variation (CV)	15.566768
Kurtosis	14059.621
Mean	71743284
Median Absolute Deviation (MAD)	4299750
Skewness	98.583765
Sum	1.4377139 × 10¹³
Variance	1.2472669 × 10¹⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	73496	36.6%
12000000	762	0.4%
9000000	758	0.4%
6000000	752	0.4%
1	694	0.3%
18000000	597	0.3%
10000000	584	0.3%
3000000	572	0.3%
15000000	566	0.3%
4000000	486	0.2%
Other values (62677)	121130	60.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-139823200	1	< 0.1%
-130438820	1	< 0.1%
-88271811	1	< 0.1%
-80483971	1	< 0.1%
-72765756	1	< 0.1%
-49673584	1	< 0.1%
-49599996	1	< 0.1%
-49524712	1	< 0.1%
-43750000	1	< 0.1%
-41284040	1	< 0.1%

Value	Count	Frequency (%)
2.133450183 × 10¹¹	1	< 0.1%
1.865070701 × 10¹¹	1	< 0.1%
1.432822371 × 10¹¹	1	< 0.1%
1.179277155 × 10¹¹	1	< 0.1%
9.689301 × 10¹⁰	1	< 0.1%
9.518281839 × 10¹⁰	1	< 0.1%
9.468352547 × 10¹⁰	1	< 0.1%
8.487290598 × 10¹⁰	1	< 0.1%
8.022376125 × 10¹⁰	1	< 0.1%
7.127073569 × 10¹⁰	1	< 0.1%

Saldo CDP
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	70969
Distinct (%)	35.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3536735 × 10⁹

Minimum	0
Maximum	4.3012743 × 10¹³
Zeros	10804
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	11213750
median	30000000
Q3	2.2630977 × 10⁸
95-th percentile	4.8087477 × 10⁹
Maximum	4.3012743 × 10¹³
Range	4.3012743 × 10¹³
Interquartile range (IQR)	2.1509602 × 10⁸

Descriptive statistics

Standard deviation	2.4131277 × 10¹¹
Coefficient of variation (CV)	71.95476
Kurtosis	30184.975
Mean	3.3536735 × 10⁹
Median Absolute Deviation (MAD)	24949000
Skewness	170.40369
Sum	6.7328014 × 10¹⁴
Variance	5.8231855 × 10²²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10804	5.4%
12000000	1259	0.6%
15000000	1235	0.6%
10000000	1100	0.5%
6000000	994	0.5%
9000000	963	0.5%
20000000	939	0.5%
18000000	872	0.4%
21000000	808	0.4%
24000000	768	0.4%
Other values (70959)	181017	90.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10804	5.4%
1	3	< 0.1%
9	1	< 0.1%
17	1	< 0.1%
32	1	< 0.1%
328	1	< 0.1%
342	1	< 0.1%
876	1	< 0.1%
2600	1	< 0.1%
42250	1	< 0.1%

Value	Count	Frequency (%)
4.301274292 × 10¹³	1	< 0.1%
4.301225174 × 10¹³	1	< 0.1%
4.30116355 × 10¹³	1	< 0.1%
4.301160446 × 10¹³	3	< 0.1%
6.750000001 × 10¹²	4	< 0.1%
6.1232 × 10¹²	1	< 0.1%
6.11985 × 10¹²	1	< 0.1%
6.11645 × 10¹²	1	< 0.1%
6.11325 × 10¹²	2	< 0.1%
6.10665 × 10¹²	1	< 0.1%

EsPostConflicto
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No	199676
Si	1018
ND	65

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	401518
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No
2nd row	No
3rd row	No
4th row	No
5th row	No

Common Values

Value	Count	Frequency (%)
No	199676	99.5%
Si	1018	0.5%
ND	65	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	199676	99.5%
si	1018	0.5%
nd	65	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	199741	49.7%
o	199676	49.7%
S	1018	0.3%
i	1018	0.3%
D	65	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	200824	50.0%
Lowercase Letter	200694	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	199741	99.5%
S	1018	0.5%
D	65	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
o	199676	99.5%
i	1018	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	401518	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	199741	49.7%
o	199676	49.7%
S	1018	0.3%
i	1018	0.3%
D	65	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	401518	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	199741	49.7%
o	199676	49.7%
S	1018	0.3%
i	1018	0.3%
D	65	< 0.1%

Destino Gasto
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Inversión	130404
Funcionamiento	69505
No Definido	850

Length

Max length	14
Median length	9
Mean length	10.739524
Min length	9

Characters and Unicode

Total characters	2156056
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Inversión
2nd row	Inversión
3rd row	Funcionamiento
4th row	Inversión
5th row	Funcionamiento

Common Values

Value	Count	Frequency (%)
Inversión	130404	65.0%
Funcionamiento	69505	34.6%
No Definido	850	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
inversión	130404	64.7%
funcionamiento	69505	34.5%
no	850	0.4%
definido	850	0.4%

Most occurring characters

Value	Count	Frequency (%)
n	470173	21.8%
i	271114	12.6%
e	200759	9.3%
o	140710	6.5%
I	130404	6.0%
v	130404	6.0%
r	130404	6.0%
s	130404	6.0%
ó	130404	6.0%
a	69505	3.2%
Other values (10)	351775	16.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1953597	90.6%
Uppercase Letter	201609	9.4%
Space Separator	850	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	470173	24.1%
i	271114	13.9%
e	200759	10.3%
o	140710	7.2%
v	130404	6.7%
r	130404	6.7%
s	130404	6.7%
ó	130404	6.7%
a	69505	3.6%
t	69505	3.6%
Other values (5)	210215	10.8%

Uppercase Letter

Value	Count	Frequency (%)
I	130404	64.7%
F	69505	34.5%
N	850	0.4%
D	850	0.4%

Space Separator

Value	Count	Frequency (%)
	850	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2155206	> 99.9%
Common	850	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	470173	21.8%
i	271114	12.6%
e	200759	9.3%
o	140710	6.5%
I	130404	6.1%
v	130404	6.1%
r	130404	6.1%
s	130404	6.1%
ó	130404	6.1%
a	69505	3.2%
Other values (9)	350925	16.3%

Common

Value	Count	Frequency (%)
	850	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2025652	94.0%
None	130404	6.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	470173	23.2%
i	271114	13.4%
e	200759	9.9%
o	140710	6.9%
I	130404	6.4%
v	130404	6.4%
r	130404	6.4%
s	130404	6.4%
a	69505	3.4%
t	69505	3.4%
Other values (9)	282270	13.9%

None

Value	Count	Frequency (%)
ó	130404	100.0%

Origen de los Recursos
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

Distribuido	168100
Recursos Propios	32659

Length

Max length	16
Median length	11
Mean length	11.813388
Min length	11

Characters and Unicode

Total characters	2371644
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Distribuido
2nd row	Distribuido
3rd row	Distribuido
4th row	Distribuido
5th row	Distribuido

Common Values

Value	Count	Frequency (%)
Distribuido	168100	83.7%
Recursos Propios	32659	16.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
distribuido	168100	72.0%
recursos	32659	14.0%
propios	32659	14.0%

Most occurring characters

Value	Count	Frequency (%)
i	536959	22.6%
s	266077	11.2%
o	266077	11.2%
r	233418	9.8%
u	200759	8.5%
D	168100	7.1%
t	168100	7.1%
b	168100	7.1%
d	168100	7.1%
R	32659	1.4%
Other values (5)	163295	6.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2105567	88.8%
Uppercase Letter	233418	9.8%
Space Separator	32659	1.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	536959	25.5%
s	266077	12.6%
o	266077	12.6%
r	233418	11.1%
u	200759	9.5%
t	168100	8.0%
b	168100	8.0%
d	168100	8.0%
e	32659	1.6%
c	32659	1.6%

Uppercase Letter

Value	Count	Frequency (%)
D	168100	72.0%
R	32659	14.0%
P	32659	14.0%

Space Separator

Value	Count	Frequency (%)
	32659	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2338985	98.6%
Common	32659	1.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	536959	23.0%
s	266077	11.4%
o	266077	11.4%
r	233418	10.0%
u	200759	8.6%
D	168100	7.2%
t	168100	7.2%
b	168100	7.2%
d	168100	7.2%
R	32659	1.4%
Other values (4)	130636	5.6%

Common

Value	Count	Frequency (%)
	32659	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2371644	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	536959	22.6%
s	266077	11.2%
o	266077	11.2%
r	233418	9.8%
u	200759	8.5%
D	168100	7.1%
t	168100	7.1%
b	168100	7.1%
d	168100	7.1%
R	32659	1.4%
Other values (5)	163295	6.9%

Dias Adicionados
Real number (ℝ)

SKEWED ZEROS

Distinct	152
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.42787621

Minimum	0
Maximum	1160
Zeros	199682
Zeros (%)	99.5%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1160
Range	1160
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.7873292
Coefficient of variation (CV)	20.537083
Kurtosis	2199.6875
Mean	0.42787621
Median Absolute Deviation (MAD)	0
Skewness	34.722273
Sum	85900
Variance	77.217154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	199682	99.5%
30	111	0.1%
31	79	< 0.1%
214	58	< 0.1%
1	43	< 0.1%
4	38	< 0.1%
244	33	< 0.1%
92	31	< 0.1%
61	30	< 0.1%
91	25	< 0.1%
Other values (142)	629	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	199682	99.5%
1	43	< 0.1%
2	18	< 0.1%
3	10	< 0.1%
4	38	< 0.1%
5	14	< 0.1%
6	14	< 0.1%
7	21	< 0.1%
8	11	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
1160	1	< 0.1%
496	1	< 0.1%
436	1	< 0.1%
412	1	< 0.1%
379	1	< 0.1%
369	1	< 0.1%
366	1	< 0.1%
365	1	< 0.1%
337	3	< 0.1%
335	1	< 0.1%

Género Representante Legal
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

No Definido	126739
Mujer	38638
Hombre	35188
Otro	194

Length

Max length	11
Median length	11
Mean length	8.9621038
Min length	4

Characters and Unicode

Total characters	1799223
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Definido
2nd row	No Definido
3rd row	No Definido
4th row	No Definido
5th row	Hombre

Common Values

Value	Count	Frequency (%)
No Definido	126739	63.1%
Mujer	38638	19.2%
Hombre	35188	17.5%
Otro	194	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	126739	38.7%
definido	126739	38.7%
mujer	38638	11.8%
hombre	35188	10.7%
otro	194	0.1%

Most occurring characters

Value	Count	Frequency (%)
o	288860	16.1%
i	253478	14.1%
e	200565	11.1%
N	126739	7.0%
	126739	7.0%
D	126739	7.0%
f	126739	7.0%
n	126739	7.0%
d	126739	7.0%
r	74020	4.1%
Other values (8)	221866	12.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1344986	74.8%
Uppercase Letter	327498	18.2%
Space Separator	126739	7.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	288860	21.5%
i	253478	18.8%
e	200565	14.9%
f	126739	9.4%
n	126739	9.4%
d	126739	9.4%
r	74020	5.5%
j	38638	2.9%
u	38638	2.9%
m	35188	2.6%
Other values (2)	35382	2.6%

Uppercase Letter

Value	Count	Frequency (%)
N	126739	38.7%
D	126739	38.7%
M	38638	11.8%
H	35188	10.7%
O	194	0.1%

Space Separator

Value	Count	Frequency (%)
	126739	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1672484	93.0%
Common	126739	7.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	288860	17.3%
i	253478	15.2%
e	200565	12.0%
N	126739	7.6%
D	126739	7.6%
f	126739	7.6%
n	126739	7.6%
d	126739	7.6%
r	74020	4.4%
j	38638	2.3%
Other values (7)	183228	11.0%

Common

Value	Count	Frequency (%)
	126739	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1799223	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	288860	16.1%
i	253478	14.1%
e	200565	11.1%
N	126739	7.0%
	126739	7.0%
D	126739	7.0%
f	126739	7.0%
n	126739	7.0%
d	126739	7.0%
r	74020	4.1%
Other values (8)	221866	12.3%

Presupuesto General de la Nacion – PGN
Real number (ℝ)

SKEWED ZEROS

Distinct	25930
Distinct (%)	12.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42256030

Minimum	0
Maximum	1.7997072 × 10¹²
Zeros	162435
Zeros (%)	80.9%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	51342468
Maximum	1.7997072 × 10¹²
Range	1.7997072 × 10¹²
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.0671607 × 10⁹
Coefficient of variation (CV)	96.250422
Kurtosis	190980.04
Mean	42256030
Median Absolute Deviation (MAD)	0
Skewness	432.14748
Sum	8.4832783 × 10¹²
Variance	1.6541796 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	162435	80.9%
30000000	95	< 0.1%
20000000	90	< 0.1%
15000000	90	< 0.1%
41973750	89	< 0.1%
10000000	86	< 0.1%
41210000	81	< 0.1%
40000000	80	< 0.1%
12000000	79	< 0.1%
27500000	78	< 0.1%
Other values (25920)	37556	18.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	162435	80.9%
3670	1	< 0.1%
7790	1	< 0.1%
34605	1	< 0.1%
59800	1	< 0.1%
67400	1	< 0.1%
68100	1	< 0.1%
79900	1	< 0.1%
85000	1	< 0.1%
99000	1	< 0.1%

Value	Count	Frequency (%)
1.79970725 × 10¹²	1	< 0.1%
1.865070701 × 10¹¹	1	< 0.1%
7.127073569 × 10¹⁰	1	< 0.1%
6.912008998 × 10¹⁰	1	< 0.1%
5.579352 × 10¹⁰	1	< 0.1%
4.50088007 × 10¹⁰	1	< 0.1%
4.20078 × 10¹⁰	1	< 0.1%
3.6525104 × 10¹⁰	1	< 0.1%
3.509137069 × 10¹⁰	1	< 0.1%
3.3404 × 10¹⁰	1	< 0.1%

Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)
Real number (ℝ)

SKEWED ZEROS

Distinct	27150
Distinct (%)	13.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22669220

Minimum	0
Maximum	1.8 × 10¹¹
Zeros	110781
Zeros (%)	55.2%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	12180874
95-th percentile	41910000
Maximum	1.8 × 10¹¹
Range	1.8 × 10¹¹
Interquartile range (IQR)	12180874

Descriptive statistics

Standard deviation	5.8576632 × 10⁸
Coefficient of variation (CV)	25.839721
Kurtosis	56461.525
Mean	22669220
Median Absolute Deviation (MAD)	0
Skewness	212.2501
Sum	4.55105 × 10¹²
Variance	3.4312218 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	110781	55.2%
12000000	1178	0.6%
9000000	1099	0.5%
6000000	1051	0.5%
15000000	878	0.4%
18000000	872	0.4%
10000000	802	0.4%
21000000	772	0.4%
8000000	641	0.3%
3000000	554	0.3%
Other values (27140)	82131	40.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	110781	55.2%
1	1	< 0.1%
9149	1	< 0.1%
13685	1	< 0.1%
18674	1	< 0.1%
39401	2	< 0.1%
46470	1	< 0.1%
48787	1	< 0.1%
51492	2	< 0.1%
73696	1	< 0.1%

Value	Count	Frequency (%)
1.8 × 10¹¹	1	< 0.1%
1.179277155 × 10¹¹	1	< 0.1%
9.699 × 10¹⁰	1	< 0.1%
3.20584563 × 10¹⁰	1	< 0.1%
2.6268 × 10¹⁰	1	< 0.1%
2.426897467 × 10¹⁰	1	< 0.1%
2.211735194 × 10¹⁰	1	< 0.1%
2.053847255 × 10¹⁰	1	< 0.1%
2.049898819 × 10¹⁰	1	< 0.1%
2 × 10¹⁰	1	< 0.1%

Recursos Propios
Real number (ℝ)

SKEWED ZEROS

Distinct	18605
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12829422

Minimum	0
Maximum	9.4683525 × 10¹⁰
Zeros	166430
Zeros (%)	82.9%
Negative	0
Negative (%)	0.0%
Memory size	3.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	32255254
Maximum	9.4683525 × 10¹⁰
Range	9.4683525 × 10¹⁰
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.6386927 × 10⁸
Coefficient of variation (CV)	28.362093
Kurtosis	32856.094
Mean	12829422
Median Absolute Deviation (MAD)	0
Skewness	156.50931
Sum	2.575622 × 10¹²
Variance	1.3240085 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	166430	82.9%
12000000	253	0.1%
6000000	247	0.1%
15000000	241	0.1%
10000000	231	0.1%
9000000	196	0.1%
24000000	178	0.1%
20000000	169	0.1%
18000000	162	0.1%
7500000	157	0.1%
Other values (18595)	32495	16.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	166430	82.9%
1	1	< 0.1%
14567	1	< 0.1%
61832	1	< 0.1%
71444	1	< 0.1%
102266	1	< 0.1%
133333	1	< 0.1%
141200	1	< 0.1%
142800	1	< 0.1%
150000	2	< 0.1%

Value	Count	Frequency (%)
9.468352547 × 10¹⁰	1	< 0.1%
6.9486 × 10¹⁰	1	< 0.1%
4.929783084 × 10¹⁰	1	< 0.1%
4.0900925 × 10¹⁰	1	< 0.1%
3.37060732 × 10¹⁰	1	< 0.1%
3.040726901 × 10¹⁰	1	< 0.1%
2.268010974 × 10¹⁰	1	< 0.1%
2.08848622 × 10¹⁰	1	< 0.1%
1.85726061 × 10¹⁰	1	< 0.1%
1.8 × 10¹⁰	1	< 0.1%

Auto

Heatmap
Table

	Valor del Contrato	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Pendiente de Ejecucion	Saldo CDP	Dias Adicionados	Presupuesto General de la Nacion – PGN	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos Propios	Departamento	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Condiciones de Entrega	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	EsPostConflicto	Destino Gasto	Origen de los Recursos	Género Representante Legal
Valor del Contrato	1.000	0.331	0.381	0.282	0.382	0.534	0.008	0.244	-0.045	0.047	0.000	0.000	0.000	0.001	0.000	0.000	0.000	0.015	0.000	0.027	0.000	0.000	0.005	0.000	0.000	0.002	0.000	0.000
Valor Facturado	0.331	1.000	-0.580	0.918	-0.583	0.174	-0.022	0.186	-0.044	-0.038	0.000	0.000	0.000	0.004	0.000	0.000	0.000	0.018	0.000	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002
Valor Pendiente de Pago	0.381	-0.580	1.000	-0.683	1.000	0.208	0.021	0.008	0.014	0.081	0.000	0.002	0.000	0.000	0.006	0.000	0.031	0.012	0.000	0.021	0.000	0.000	0.012	0.000	0.000	0.000	0.000	0.000
Valor Pagado	0.282	0.918	-0.683	1.000	-0.686	0.149	-0.019	0.175	-0.058	-0.040	0.000	0.000	0.000	0.004	0.000	0.000	0.000	0.018	0.000	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002
Valor Pendiente de Ejecucion	0.382	-0.583	1.000	-0.686	1.000	0.209	0.021	0.009	0.014	0.081	0.000	0.008	0.008	0.000	0.010	0.015	0.033	0.031	0.000	0.054	0.000	0.000	0.022	0.000	0.000	0.000	0.000	0.000
Saldo CDP	0.534	0.174	0.208	0.149	0.209	1.000	0.043	0.244	-0.094	-0.015	0.007	0.004	0.025	0.000	0.006	0.004	0.000	0.015	0.004	0.000	0.001	0.000	0.003	0.000	0.000	0.008	0.003	0.007
Dias Adicionados	0.008	-0.022	0.021	-0.019	0.021	0.043	1.000	-0.029	-0.047	0.005	0.019	0.014	0.040	0.011	0.020	0.023	0.024	0.040	0.013	0.010	0.000	0.000	0.010	0.003	0.000	0.029	0.005	0.015
Presupuesto General de la Nacion – PGN	0.244	0.186	0.008	0.175	0.009	0.244	-0.029	1.000	-0.404	-0.177	0.000	0.000	0.000	0.001	0.000	0.000	0.000	0.019	0.000	0.027	0.000	0.000	0.007	0.000	0.000	0.000	0.000	0.000
Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	-0.045	-0.044	0.014	-0.058	0.014	-0.094	-0.047	-0.404	1.000	-0.367	0.000	0.000	0.000	0.000	0.004	0.004	0.006	0.024	0.000	0.019	0.005	0.000	0.007	0.000	0.000	0.000	0.000	0.000
Recursos Propios	0.047	-0.038	0.081	-0.040	0.081	-0.015	0.005	-0.177	-0.367	1.000	0.000	0.019	0.011	0.005	0.007	0.007	0.075	0.019	0.000	0.027	0.000	0.000	0.014	0.000	0.000	0.000	0.021	0.000
Departamento	0.000	0.000	0.000	0.000	0.000	0.007	0.019	0.000	0.000	0.000	1.000	0.275	0.195	0.131	0.325	0.213	0.055	0.091	0.131	0.061	0.106	0.042	0.251	0.206	0.060	0.179	0.174	0.166
Orden	0.000	0.000	0.002	0.000	0.008	0.004	0.014	0.000	0.000	0.019	0.275	1.000	0.569	0.241	0.122	0.071	0.172	0.164	0.156	0.022	0.142	0.007	0.099	0.224	0.053	0.068	0.199	0.159
Sector	0.000	0.000	0.000	0.000	0.008	0.025	0.040	0.000	0.000	0.011	0.195	0.569	1.000	0.395	0.377	0.178	0.118	0.209	0.151	0.059	0.222	0.014	0.302	0.486	0.194	0.333	0.389	0.166
Rama	0.001	0.004	0.000	0.004	0.000	0.000	0.011	0.001	0.000	0.005	0.131	0.241	0.395	1.000	0.042	0.047	0.152	0.135	0.088	0.016	0.080	0.007	0.101	0.046	0.044	0.147	0.313	0.047
Entidad Centralizada	0.000	0.000	0.006	0.000	0.010	0.006	0.020	0.000	0.004	0.007	0.325	0.122	0.377	0.042	1.000	0.058	0.086	0.109	0.148	0.014	0.036	0.007	0.034	0.120	0.040	0.045	0.138	0.057
Estado Contrato	0.000	0.000	0.000	0.000	0.015	0.004	0.023	0.000	0.004	0.007	0.213	0.071	0.178	0.047	0.058	1.000	0.170	0.214	0.049	0.176	0.082	0.025	0.079	0.015	0.029	0.052	0.042	0.033
Tipo de Contrato	0.000	0.000	0.031	0.000	0.033	0.000	0.024	0.000	0.006	0.075	0.055	0.172	0.118	0.152	0.086	0.170	1.000	0.514	0.051	0.349	0.399	0.265	0.242	0.045	0.012	0.189	0.156	0.114
Modalidad de Contratacion	0.015	0.018	0.012	0.018	0.031	0.015	0.040	0.019	0.024	0.019	0.091	0.164	0.209	0.135	0.109	0.214	0.514	1.000	0.057	0.486	0.517	0.111	0.323	0.070	0.056	0.249	0.189	0.130
Condiciones de Entrega	0.000	0.000	0.000	0.000	0.000	0.004	0.013	0.000	0.000	0.000	0.131	0.156	0.151	0.088	0.148	0.049	0.051	0.057	1.000	0.015	0.092	0.000	0.181	0.430	0.014	0.096	0.078	0.056
Es Grupo	0.027	0.013	0.021	0.013	0.054	0.000	0.010	0.027	0.019	0.027	0.061	0.022	0.059	0.016	0.014	0.176	0.349	0.486	0.015	1.000	0.010	0.033	0.085	0.009	0.013	0.000	0.007	0.053
Es Pyme	0.000	0.000	0.000	0.000	0.000	0.001	0.000	0.000	0.005	0.000	0.106	0.142	0.222	0.080	0.036	0.082	0.399	0.517	0.092	0.010	1.000	0.011	0.165	0.042	0.000	0.080	0.024	0.177
Habilita Pago Adelantado	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.042	0.007	0.014	0.007	0.007	0.025	0.265	0.111	0.000	0.033	0.011	1.000	0.008	0.000	0.000	0.003	0.007	0.023
Liquidación	0.005	0.000	0.012	0.000	0.022	0.003	0.010	0.007	0.007	0.014	0.251	0.099	0.302	0.101	0.034	0.079	0.242	0.323	0.181	0.085	0.165	0.008	1.000	0.037	0.005	0.104	0.049	0.096
Obligación Ambiental	0.000	0.000	0.000	0.000	0.000	0.000	0.003	0.000	0.000	0.000	0.206	0.224	0.486	0.046	0.120	0.015	0.045	0.070	0.430	0.009	0.042	0.000	0.037	1.000	0.009	0.087	0.043	0.083
EsPostConflicto	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.060	0.053	0.194	0.044	0.040	0.029	0.012	0.056	0.014	0.013	0.000	0.000	0.005	0.009	1.000	0.195	0.031	0.009
Destino Gasto	0.002	0.000	0.000	0.000	0.000	0.008	0.029	0.000	0.000	0.000	0.179	0.068	0.333	0.147	0.045	0.052	0.189	0.249	0.096	0.000	0.080	0.003	0.104	0.087	0.195	1.000	0.121	0.044
Origen de los Recursos	0.000	0.000	0.000	0.000	0.000	0.003	0.005	0.000	0.000	0.021	0.174	0.199	0.389	0.313	0.138	0.042	0.156	0.189	0.078	0.007	0.024	0.007	0.049	0.043	0.031	0.121	1.000	0.071
Género Representante Legal	0.000	0.002	0.000	0.002	0.000	0.007	0.015	0.000	0.000	0.000	0.166	0.159	0.166	0.047	0.057	0.033	0.114	0.130	0.056	0.053	0.177	0.023	0.096	0.083	0.009	0.044	0.071	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Departamento	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Fecha de Firma	Fecha de Inicio del Contrato	Fecha de Fin del Contrato	Fecha de Inicio de Ejecucion	Fecha de Fin de Ejecucion	Condiciones de Entrega	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	Valor del Contrato	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Pendiente de Ejecucion	Saldo CDP	EsPostConflicto	Destino Gasto	Origen de los Recursos	Género Representante Legal	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos Propios
2403711	Distrito Capital de Bogotá	Territorial	Planeación	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2021-04-15	2021-04-19	2021-12-30	NaT	NaT	No Definido	No	No	No	No	No	68000000	68000000	799996	67200004	799996.0	76000000	No	Inversión	Distribuido	No Definido	68000000	0
2286389	Valle del Cauca	Territorial	deportes	Ejecutivo	Descentralizada	Cerrado	Prestación de servicios	Contratación directa	2021-11-24	2021-11-26	2021-12-27	NaT	NaT	Como acordado previamente	No	No	No	No	No	3600000	0	3600000	0	3600000.0	3600000	No	Inversión	Distribuido	No Definido	3600000	0
1152985	Distrito Capital de Bogotá	Territorial	Salud y Protección Social	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación régimen especial	2020-03-24	2020-02-01	2020-02-29	2020-02-01	2020-02-29	A convenir	No	Si	No	No	No	2321700	0	2321700	0	2321700.0	0	No	Funcionamiento	Distribuido	No Definido	0	0
473693	Boyacá	Territorial	Servicio Público	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación directa	2020-10-06	2020-10-06	2020-12-31	NaT	NaT	A convenir	No	No	No	No	No	104758396	0	104758396	0	104758396.0	104758396	No	Inversión	Distribuido	No Definido	0	0
435778	Risaralda	Territorial	Servicio Público	Ejecutivo	Descentralizada	Cerrado	Prestación de servicios	Contratación directa	2022-08-16	2022-08-18	2022-12-28	NaT	NaT	A convenir	No	No	No	No	No	11711700	11711700	0	11711700	0.0	11711700	No	Funcionamiento	Distribuido	Hombre	11711700	0
1909582	Valle del Cauca	Territorial	Servicio Público	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2022-01-28	2022-02-14	2022-12-30	NaT	NaT	A convenir	No	Si	No	No	No	37485000	0	37485000	0	37485000.0	37485000	No	Inversión	Distribuido	Mujer	37485000	0
927373	Distrito Capital de Bogotá	Territorial	Ambiente y Desarrollo Sostenible	Corporación Autónoma	Descentralizada	terminado	Prestación de servicios	Contratación directa	2021-05-20	2021-05-25	2022-01-06	NaT	NaT	A convenir	No	No	No	No	No	13024000	13024000	13024000	0	13024000.0	13024000	No	Inversión	Distribuido	No Definido	13024000	0
1414269	Distrito Capital de Bogotá	Nacional	Educación Nacional	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación régimen especial	2020-06-19	2020-06-23	2020-12-31	NaT	NaT	No Definido	No	No	No	No	No	39734408	28760143	39734408	0	39734408.0	39734408	No	Funcionamiento	Recursos Propios	No Definido	0	39734408
297285	Valle del Cauca	Territorial	deportes	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2019-02-21	2019-02-25	2019-04-25	NaT	NaT	No Definido	No	No	No	No	No	3184000	0	3184000	0	3184000.0	6368000	No	Inversión	Distribuido	No Definido	0	0
2439291	Bolívar	Territorial	Servicio Público	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación directa	2022-09-29	2022-09-29	2022-12-28	NaT	NaT	A convenir	No	No	No	No	No	9600000	9600000	9600000	0	9600000.0	639061200	No	Inversión	Distribuido	Mujer	9600000	0

	Departamento	Orden	Sector	Rama	Entidad Centralizada	Estado Contrato	Tipo de Contrato	Modalidad de Contratacion	Fecha de Firma	Fecha de Inicio del Contrato	Fecha de Fin del Contrato	Fecha de Inicio de Ejecucion	Fecha de Fin de Ejecucion	Condiciones de Entrega	Es Grupo	Es Pyme	Habilita Pago Adelantado	Liquidación	Obligación Ambiental	Valor del Contrato	Valor Facturado	Valor Pendiente de Pago	Valor Pagado	Valor Pendiente de Ejecucion	Saldo CDP	EsPostConflicto	Destino Gasto	Origen de los Recursos	Dias Adicionados	Género Representante Legal	Presupuesto General de la Nacion – PGN	Recursos Propios (Alcaldías, Gobernaciones y Resguardos Indígenas)	Recursos Propios
1300745	Distrito Capital de Bogotá	Territorial	Industria	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2020-05-06	2020-05-07	2020-11-06	NaT	NaT	Como acordado previamente	No	No	No	No	No	20400000	20400000	0	20400000	0.0	18000000	No	Inversión	Distribuido	0	No Definido	0	20400000	0
1570387	Nariño	Nacional	Salud y Protección Social	Ejecutivo	Centralizada	terminado	Otro	Contratación régimen especial	2020-09-23	2020-09-24	2020-12-15	NaT	NaT	Como acordado previamente	No	No	No	No	No	54427050	0	54427050	0	54427050.0	54427050	No	Inversión	Distribuido	0	No Definido	54427050	0	0
1043363	Risaralda	Territorial	Servicio Público	Ejecutivo	Descentralizada	Cerrado	Prestación de servicios	Contratación directa	2021-05-28	2021-06-01	2021-12-30	NaT	NaT	Como acordado previamente	No	Si	No	No	No	14182000	14182000	0	14182000	0.0	14182000	No	Inversión	Distribuido	0	Mujer	0	14182000	0
1351412	Santander	Territorial	Servicio Público	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2022-01-14	2022-01-17	2022-05-17	NaT	NaT	A convenir	No	No	No	No	No	8000000	8000000	0	8000000	0.0	8000000	No	Inversión	Distribuido	0	Mujer	0	8000000	0
1187273	Risaralda	Territorial	Servicio Público	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación directa	2021-01-14	2021-01-18	2021-08-17	NaT	NaT	No Definido	No	No	No	No	No	14182000	0	14182000	0	14182000.0	14182000	No	Inversión	Distribuido	0	No Definido	0	14182000	0
22748	Distrito Capital de Bogotá	Nacional	Cultura	Ejecutivo	Centralizada	terminado	DecreeLaw092/2017	Contratación régimen especial	2021-12-08	2021-12-09	2021-12-15	NaT	NaT	No Definido	No	Si	No	No	No	50000000	0	50000000	0	50000000.0	50000000	No	Funcionamiento	Distribuido	0	No Definido	45000000	0	5000000
1276938	Santander	Territorial	Servicio Público	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2021-10-21	2021-10-26	2021-12-26	NaT	NaT	A convenir	No	No	No	No	No	3400000	3400000	0	3400000	0.0	3400000	No	Inversión	Distribuido	0	Mujer	0	3400000	0
1906790	Santander	Territorial	Servicio Público	Ejecutivo	Centralizada	terminado	Prestación de servicios	Contratación directa	2022-09-20	2022-09-27	2022-12-26	NaT	NaT	No Definido	No	No	No	No	No	5100000	5100000	5100000	0	5100000.0	0	No	Inversión	Distribuido	0	Mujer	0	5100000	0
935701	Huila	Nacional	Trabajo	Ejecutivo	Descentralizada	terminado	Prestación de servicios	Contratación directa	2020-01-31	2020-02-02	2020-12-09	2020-02-02	2020-12-09	Transporte incluido	No	No	No	No	Si	36737667	36737667	0	36737667	0.0	1284691667	No	Inversión	Distribuido	7	No Definido	0	0	0
1226909	Santander	Nacional	Trabajo	Ejecutivo	Descentralizada	terminado	Compraventa	Contratación Directa (con ofertas)	2021-04-30	2021-05-06	2021-05-20	NaT	NaT	Transporte incluido	No	No	No	No	Si	5704776	5704776	0	5704776	0.0	5717250	No	Inversión	Distribuido	0	Hombre	5704776	0	0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts